/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost:3306
 Source Schema         : platform

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 13/11/2018 16:47:44
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(256) NOT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL,
  `authentication` blob,
  `refresh_token` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of oauth_access_token
-- ----------------------------
BEGIN;
INSERT INTO `oauth_access_token` VALUES ('67a6364328668771299e533d7513e2ce', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E00057870737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F72646572787200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000002740009757365725F696E666F73720028636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E55736572E081D1B32366716902000C4900037365784C00076164647265737371007E00054C000661766174617271007E00054C0008626972746864617971007E00054C0005656D61696C71007E00054C000667726F7570737400104C6A6176612F7574696C2F4C6973743B4C00086E69636B6E616D6571007E00054C00056F726749647400104C6A6176612F6C616E672F4C6F6E673B4C000870617373776F726471007E00054C000570686F6E6571007E00054C000573746174657400134C6A6176612F6C616E672F496E74656765723B4C0008757365726E616D6571007E000578720022636F6D2E66756E6361732E70626F6F742E636F6D6D6F6E2E42617365456E7469747900000000000000010200014C000269647400124C6A6176612F6C616E672F4F626A6563743B78707372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000050000000070707074001F61646D696E6973747261746F7240626173656672616D65776F726B2E636F6D7074000FE8B685E7BAA7E7AEA1E79086E591987371007E001200000000000000027070737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E00130000000174000561646D696E7400036A746974002465363236613931612D356263352D343033622D396434302D65666439396635663837306278007372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000166EF101F15787372004C6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744578706972696E674F417574683252656672657368546F6B656E2FDF47639DD0C9B70200014C000A65787069726174696F6E71007E0002787200446F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F417574683252656672657368546F6B656E73E10E0A6354D45E0200014C000576616C756571007E000578707405C765794A68624763694F694A53557A49314E694973496E523563434936496B705856434A392E65794A316332567958326C755A6D38694F6E7369615751694F6A5573496D567459576C73496A6F6959575274615735706333527959585276636B426959584E6C5A6E4A686257563362334A724C6D4E7662534973496E426863334E3362334A6B496A7075645778734C434A7561574E72626D46745A5349364975693268656536702D65756F656551687557526D434973496E4E305958526C496A6F784C434A3163325679626D46745A534936496D466B62576C754969776959585A6864474679496A7075645778734C434A77614739755A534936626E56736243776963325634496A6F774C434A6961584A306147526865534936626E5673624377695957526B636D567A63794936626E56736243776962334A6E535751694F6A4973496D64796233567763794936626E56736243776962334A6E59573570656D463061573975496A7075645778736653776964584E6C636C39755957316C496A6F6959575274615734694C434A7A593239775A53493657794A68634841695853776959585270496A6F695A5459794E6D45354D5745744E574A6A4E5330304D444E694C546C6B4E4441745A575A6B4F546C6D4E5759344E7A4269496977695A586877496A6F784E5451304D5455324D7A55794C434A686458526F62334A7064476C6C6379493657794A6B595852684C5752705933527062323568636E6B3662476C7A64434973496E567A5A58493662476C7A64434973496E567A5A5849365A4756735A58526C496977695A334A76645841365A57527064434973496D6479623356774F6D526C624756305A534973496E4A6C63323931636D4E6C4F6D566B615851694C434A795A584E7664584A6A5A54706B5A57786C644755694C434A7A65584D694C434A6B61574E306157397559584A354C574E686447566E62334A354F6D526C624756305A534973496D52705933527062323568636E6B74593246305A576476636E6B3662476C7A64434973496E4A6C63323931636D4E6C4F6E4E68646D55694C434A6B595852684C5752705933527062323568636E6B365A57527064434973496D52705933527062323568636E6B74593246305A576476636E6B36633246325A534973496E567A5A5849365A57527064434973496E567762584D694C434A31626D6C304F6D7870633351694C434A6B595852684C5752705933527062323568636E6B365A4756735A58526C49697769636D567A623356795932553662476C7A64434973496D6479623356774F6D7870633351694C434A6B595852684C5752705933527062323568636E6B36633246325A534973496E567A5A584936633246325A534973496D52705933527062323568636E6B74593246305A576476636E6B365A57527064434973496D6479623356774F6E4E68646D556958537769616E5270496A6F694D54593559545A6A4D7A6B744F574D314D6930305A47526D4C546C6B59324D744D6A4A6C5A6A6C6D4E7A4E6B4F575A6A49697769593278705A57353058326C6B496A6F6959584277496E302E4362697837766C4A5566556775507236686444725072792D45696A4E374865334A59346A656F577541566368305F57364A45565351642D4F384748626C706A477173705676763441763274725570536A707444477A4C6B456D496364416C4B79594C704B38592D7050724C316878776C726A62466C4B39433849796D58564C69506355745A6650374D5A646338504B61683645426C4E57314A684E7A514E67454D623578547A4846706B6A553035755F4B46574F37317334644B6F5678736F7A3254306456587A434D486A4C6C42367357552D4B6633706E6376426C65506B58747A6B6F4969314B4F6E365934475759706E58322D74364566504B7A6865766750464152764373443468734961566859586445433559686264755978334E7A4C384B6C444C59587754437543385F567A5477526C4B364638546D357A5446447030303367633878536644493372336E356F6F504437417371007E001D77080000016786E40FA678737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017400036170707874000662656172657274058B65794A68624763694F694A53557A49314E694973496E523563434936496B705856434A392E65794A316332567958326C755A6D38694F6E7369615751694F6A5573496D567459576C73496A6F6959575274615735706333527959585276636B426959584E6C5A6E4A686257563362334A724C6D4E7662534973496E426863334E3362334A6B496A7075645778734C434A7561574E72626D46745A5349364975693268656536702D65756F656551687557526D434973496E4E305958526C496A6F784C434A3163325679626D46745A534936496D466B62576C754969776959585A6864474679496A7075645778734C434A77614739755A534936626E56736243776963325634496A6F774C434A6961584A306147526865534936626E5673624377695957526B636D567A63794936626E56736243776962334A6E535751694F6A4973496D64796233567763794936626E56736243776962334A6E59573570656D463061573975496A7075645778736653776964584E6C636C39755957316C496A6F6959575274615734694C434A7A593239775A53493657794A6863484169585377695A586877496A6F784E5451784E6A41354D54417A4C434A686458526F62334A7064476C6C6379493657794A6B595852684C5752705933527062323568636E6B3662476C7A64434973496E567A5A58493662476C7A64434973496E567A5A5849365A4756735A58526C496977695A334A76645841365A57527064434973496D6479623356774F6D526C624756305A534973496E4A6C63323931636D4E6C4F6D566B615851694C434A795A584E7664584A6A5A54706B5A57786C644755694C434A7A65584D694C434A6B61574E306157397559584A354C574E686447566E62334A354F6D526C624756305A534973496D52705933527062323568636E6B74593246305A576476636E6B3662476C7A64434973496E4A6C63323931636D4E6C4F6E4E68646D55694C434A6B595852684C5752705933527062323568636E6B365A57527064434973496D52705933527062323568636E6B74593246305A576476636E6B36633246325A534973496E567A5A5849365A57527064434973496E567762584D694C434A31626D6C304F6D7870633351694C434A6B595852684C5752705933527062323568636E6B365A4756735A58526C49697769636D567A623356795932553662476C7A64434973496D6479623356774F6D7870633351694C434A6B595852684C5752705933527062323568636E6B36633246325A534973496E567A5A584936633246325A534973496D52705933527062323568636E6B74593246305A576476636E6B365A57527064434973496D6479623356774F6E4E68646D556958537769616E5270496A6F695A5459794E6D45354D5745744E574A6A4E5330304D444E694C546C6B4E4441745A575A6B4F546C6D4E5759344E7A426949697769593278705A57353058326C6B496A6F6959584277496E302E614E706F545648352D3051532D676736526F6F3433684E39583936352D58697A726D53454D4558653273395F45564F497A72624A7352656667587133424A7945563172786E4B72486F5A674536797375593246454B684333707A456A697351655A334B336D694B4F5F7A336150335833533142564A334C714B48493939474670343951703368706377566474517741315377346A6B6F594D54462D494766693748354F6639414A6E73534A4E4D69686B6D41654D6A4E4F57344C4970337A56523054684C4C646D6F7A41476F5162485541626A6B6777477149514361456A4D346642526362465A7241534E6832617744423854636565666B4375442D57385964517576574755594950346869534F6A55794F7A5F3773536F324B6152595538785952455354346472574D45394F774B4366786E52367A394B6B346752306C475F4D53327568376A635169376364555355774648763177, 'b9cdd625a781099755dfb47c3de1e150', 'admin', 'app', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000017770400000017737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000001F40200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740016646174612D64696374696F6E6172793A64656C6574657371007E000D740014646174612D64696374696F6E6172793A656469747371007E000D740014646174612D64696374696F6E6172793A6C6973747371007E000D740014646174612D64696374696F6E6172793A736176657371007E000D74001A64696374696F6E6172792D63617465676F72793A64656C6574657371007E000D74001864696374696F6E6172792D63617465676F72793A656469747371007E000D74001864696374696F6E6172792D63617465676F72793A6C6973747371007E000D74001864696374696F6E6172792D63617465676F72793A736176657371007E000D74000C67726F75703A64656C6574657371007E000D74000A67726F75703A656469747371007E000D74000A67726F75703A6C6973747371007E000D74000A67726F75703A736176657371007E000D74000F7265736F757263653A64656C6574657371007E000D74000D7265736F757263653A656469747371007E000D74000D7265736F757263653A6C6973747371007E000D74000D7265736F757263653A736176657371007E000D7400037379737371007E000D740009756E69743A6C6973747371007E000D74000475706D737371007E000D74000B757365723A64656C6574657371007E000D740009757365723A656469747371007E000D740009757365723A6C6973747371007E000D740009757365723A736176657871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E0040787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E003E4C000573636F706571007E00407870740003617070737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E003E7870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000037708000000040000000274000A6772616E745F7479706574000870617373776F7264740008757365726E616D6574000561646D696E78737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000174000361707078017371007E004F770C000000103F40000000000000787371007E00463F40000000000000770800000010000000007870707371007E004F770C000000103F40000000000000787371007E004F770C000000103F40000000000000787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000001F40200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000001777040000001771007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B7871007E0059737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F726465727871007E00463F400000000000067708000000080000000271007E004871007E004971007E004A71007E004B78007073720032636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E426173655573657244657461696C52BF9FE5F1A3EC3A0200024C0004757365727400344C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F7573657264657461696C732F557365723B4C000675736572564F74002A4C636F6D2F66756E6361732F70626F6F742F6D6F64756C652F75706D732F656E746974792F557365723B7870737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000001F40200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00404C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E004C737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F7200000000000001F4020000787077040000001771007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B787074000561646D696E73720028636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E55736572E081D1B32366716902000C4900037365784C00076164647265737371007E000E4C000661766174617271007E000E4C0008626972746864617971007E000E4C0005656D61696C71007E000E4C000667726F75707371007E00084C00086E69636B6E616D6571007E000E4C00056F726749647400104C6A6176612F6C616E672F4C6F6E673B4C000870617373776F726471007E000E4C000570686F6E6571007E000E4C000573746174657400134C6A6176612F6C616E672F496E74656765723B4C0008757365726E616D6571007E000E78720022636F6D2E66756E6361732E70626F6F742E636F6D6D6F6E2E42617365456E7469747900000000000000010200014C0002696471007E000578707372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000050000000070707074001F61646D696E6973747261746F7240626173656672616D65776F726B2E636F6D7074000FE8B685E7BAA7E7AEA1E79086E591987371007E006D000000000000000274003C243261243036242F56494E6335766C613854356359464B51506941442E69584D754356346B616D762F6F6C7A51533141524265596F6F6D6B4D554F6170737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E006E0000000171007E0067, 'fec9776256503033887e163440654135');
INSERT INTO `oauth_access_token` VALUES ('5f817fc61a524174234c88867a812e46', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E00057870737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F72646572787200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000002740009757365725F696E666F73720028636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E55736572E081D1B32366716902000C4900037365784C00076164647265737371007E00054C000661766174617271007E00054C0008626972746864617971007E00054C0005656D61696C71007E00054C000667726F7570737400104C6A6176612F7574696C2F4C6973743B4C00086E69636B6E616D6571007E00054C00056F726749647400104C6A6176612F6C616E672F4C6F6E673B4C000870617373776F726471007E00054C000570686F6E6571007E00054C000573746174657400134C6A6176612F6C616E672F496E74656765723B4C0008757365726E616D6571007E000578720022636F6D2E66756E6361732E70626F6F742E636F6D6D6F6E2E42617365456E7469747900000000000000010200014C000269647400124C6A6176612F6C616E672F4F626A6563743B78707372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700E4A1F857C40000000000001707074000074000C31313131403134332E636F6D70740003667373707070737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017400036673737400036A746974002438393938663733372D373663382D343637382D623531342D30376566363130326134303778007372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000166EF657B6B787372004C6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744578706972696E674F417574683252656672657368546F6B656E2FDF47639DD0C9B70200014C000A65787069726174696F6E71007E0002787200446F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F417574683252656672657368546F6B656E73E10E0A6354D45E0200014C000576616C756571007E0005787074059865794A68624763694F694A53557A49314E694973496E523563434936496B705856434A392E65794A316332567958326C755A6D38694F6E7369615751694F6A45774D6A6B324E7A41784D6A49354F444D794E6A41784E6A4173496D567459576C73496A6F694D5445784D5541784E444D7559323974496977696347467A63336476636D51694F6D353162477773496D3570593274755957316C496A6F695A6E4E7A4969776963335268644755694F6A4573496E567A5A584A755957316C496A6F695A6E4E7A4969776959585A6864474679496A7075645778734C434A77614739755A534936626E56736243776963325634496A6F784C434A6961584A30614752686553493649694973496D466B5A484A6C63334D694F6D353162477773496D39795A306C6B496A7075645778734C434A6E636D393163484D694F6D353162477773496D39795A3246756158706864476C7662694936626E567362483073496E567A5A584A66626D46745A534936496D5A7A63794973496E4E6A6233426C496A7062496D467763434A644C434A6864476B694F6949344F546B345A6A637A4E7930334E6D4D344C5451324E7A6774596A55784E4330774E32566D4E6A45774D6D45304D4463694C434A6C654841694F6A45314E4451784E6A4D7A4D6A4D73496D463164476876636D6C306157567A496A7062496D5268644745745A476C6A64476C76626D46796554707361584E304969776964584E6C636A707361584E304969776964584E6C636A706B5A57786C644755694C434A6E636D39316344706C5A476C30496977695A334A76645841365A4756735A58526C49697769636D567A62335679593255365A57527064434973496E4A6C63323931636D4E6C4F6D526C624756305A534973496E4E3563794973496D52705933527062323568636E6B74593246305A576476636E6B365A4756735A58526C496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707361584E3049697769636D567A6233567959325536633246325A534973496D5268644745745A476C6A64476C76626D46796554706C5A476C30496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707A59585A6C4969776964584E6C636A706C5A476C30496977695A4746305953316B61574E306157397559584A354F6D526C624756305A534973496E4A6C63323931636D4E6C4F6D7870633351694C434A6E636D39316344707361584E30496977695A4746305953316B61574E306157397559584A354F6E4E68646D55694C434A31633256794F6E4E68646D55694C434A6B61574E306157397559584A354C574E686447566E62334A354F6D566B615851694C434A6E636D39316344707A59585A6C496C3073496D703061534936496A55774D54417A596D45304C5463794E6A67744E474E6C4F4331684E6D466B4C544D324E54426D4F4463324E324E6A4F434973496D4E7361575675644639705A434936496D467763434A392E4A5845544B594B4F66616B657A61356C52506861587455484A41626671793453346E315446506975677761624F615972625741354C70427A613738527652446F32447354386E774F7A434747334E62733931337377504533432D3668385155504B69494D58643450623730694D786B5772376753744454374B38446F786D6A5265384B557165747074704F413461453033595A51696B4763385833566174377970376B747133793362755A76676D51466D6555593445777241656D374E434258555570714C70787530596A78675F3138655854494A6C2D43504E646361696D306A5474435747575F41736C64535978454C506C325569474A6B72683977534968594249784F2D42532D5531744E6E565643582D524B49384E68797A706C4D66366C4177756164626B786466327431476C50796E675070773151793568694D755065785A6E646A6C544F326835494D44545042493461677371007E001D770800000167874E6EAC78737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017400036170707874000662656172657274055C65794A68624763694F694A53557A49314E694973496E523563434936496B705856434A392E65794A316332567958326C755A6D38694F6E7369615751694F6A45774D6A6B324E7A41784D6A49354F444D794E6A41784E6A4173496D567459576C73496A6F694D5445784D5541784E444D7559323974496977696347467A63336476636D51694F6D353162477773496D3570593274755957316C496A6F695A6E4E7A4969776963335268644755694F6A4573496E567A5A584A755957316C496A6F695A6E4E7A4969776959585A6864474679496A7075645778734C434A77614739755A534936626E56736243776963325634496A6F784C434A6961584A30614752686553493649694973496D466B5A484A6C63334D694F6D353162477773496D39795A306C6B496A7075645778734C434A6E636D393163484D694F6D353162477773496D39795A3246756158706864476C7662694936626E567362483073496E567A5A584A66626D46745A534936496D5A7A63794973496E4E6A6233426C496A7062496D467763434A644C434A6C654841694F6A45314E4445324D5451324F546373496D463164476876636D6C306157567A496A7062496D5268644745745A476C6A64476C76626D46796554707361584E304969776964584E6C636A707361584E304969776964584E6C636A706B5A57786C644755694C434A6E636D39316344706C5A476C30496977695A334A76645841365A4756735A58526C49697769636D567A62335679593255365A57527064434973496E4A6C63323931636D4E6C4F6D526C624756305A534973496E4E3563794973496D52705933527062323568636E6B74593246305A576476636E6B365A4756735A58526C496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707361584E3049697769636D567A6233567959325536633246325A534973496D5268644745745A476C6A64476C76626D46796554706C5A476C30496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707A59585A6C4969776964584E6C636A706C5A476C30496977695A4746305953316B61574E306157397559584A354F6D526C624756305A534973496E4A6C63323931636D4E6C4F6D7870633351694C434A6E636D39316344707361584E30496977695A4746305953316B61574E306157397559584A354F6E4E68646D55694C434A31633256794F6E4E68646D55694C434A6B61574E306157397559584A354C574E686447566E62334A354F6D566B615851694C434A6E636D39316344707A59585A6C496C3073496D703061534936496A67354F54686D4E7A4D334C546332597A67744E4459334F4331694E5445304C5441335A5759324D544179595451774E794973496D4E7361575675644639705A434936496D467763434A392E46476761484A46756E7638774C66706F466B43714B476D335F375442463262764174456132564C71506B622D4E6A50577461656C5F53304C4962336C3047576F4867554C34584C307565515334337971365459417470454478655658476737527477335843743332674378794E773177655F387139597A6C6A7432684774526175586C66786C4E6F6D685A6274764F46784A595146667A6930524E4C52626139445035395F6A74695355504D546D4C373778466D6573314C374E38446E4A785861632D58434163454572376455435A4638574754427465697148546C644A68633649414F4C7A495032344F57434E494547576235557A746D2D6338787664587732704D73463466313332425134522D487074743079656D45433034644F5531455F73546F7A575F2D516369515150346C4F4F474D444A446D49306D5155505A4437413631506A61585F524F3655685F69754938525641, 'ca943fda41d130ca2a4ead8ed4b55440', 'fss', 'app', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000015770400000015737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000001F40200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740016646174612D64696374696F6E6172793A64656C6574657371007E000D740014646174612D64696374696F6E6172793A656469747371007E000D740014646174612D64696374696F6E6172793A6C6973747371007E000D740014646174612D64696374696F6E6172793A736176657371007E000D74001A64696374696F6E6172792D63617465676F72793A64656C6574657371007E000D74001864696374696F6E6172792D63617465676F72793A656469747371007E000D74001864696374696F6E6172792D63617465676F72793A6C6973747371007E000D74001864696374696F6E6172792D63617465676F72793A736176657371007E000D74000C67726F75703A64656C6574657371007E000D74000A67726F75703A656469747371007E000D74000A67726F75703A6C6973747371007E000D74000A67726F75703A736176657371007E000D74000F7265736F757263653A64656C6574657371007E000D74000D7265736F757263653A656469747371007E000D74000D7265736F757263653A6C6973747371007E000D74000D7265736F757263653A736176657371007E000D7400037379737371007E000D74000B757365723A64656C6574657371007E000D740009757365723A656469747371007E000D740009757365723A6C6973747371007E000D740009757365723A736176657871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E003C787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E003A4C000573636F706571007E003C7870740003617070737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E003A7870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000037708000000040000000274000A6772616E745F7479706574000870617373776F7264740008757365726E616D6574000366737378737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000174000361707078017371007E004B770C000000103F40000000000000787371007E00423F40000000000000770800000010000000007870707371007E004B770C000000103F40000000000000787371007E004B770C000000103F40000000000000787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000001F40200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000001577040000001571007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E00377871007E0055737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F726465727871007E00423F400000000000067708000000080000000271007E004471007E004571007E004671007E004778007073720032636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E426173655573657244657461696C52BF9FE5F1A3EC3A0200024C0004757365727400344C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F7573657264657461696C732F557365723B4C000675736572564F74002A4C636F6D2F66756E6361732F70626F6F742F6D6F64756C652F75706D732F656E746974792F557365723B7870737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000001F40200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E003C4C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E0048737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F7200000000000001F4020000787077040000001571007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E0037787074000366737373720028636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E55736572E081D1B32366716902000C4900037365784C00076164647265737371007E000E4C000661766174617271007E000E4C0008626972746864617971007E000E4C0005656D61696C71007E000E4C000667726F75707371007E00084C00086E69636B6E616D6571007E000E4C00056F726749647400104C6A6176612F6C616E672F4C6F6E673B4C000870617373776F726471007E000E4C000570686F6E6571007E000E4C000573746174657400134C6A6176612F6C616E672F496E74656765723B4C0008757365726E616D6571007E000E78720022636F6D2E66756E6361732E70626F6F742E636F6D6D6F6E2E42617365456E7469747900000000000000010200014C0002696471007E000578707372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700E4A1F857C40000000000001707074000074000C31313131403134332E636F6D707400036673737074003C243261243036244A4F3558704E53596A67375151724E3566714237597561506B4267764A6F2E76704930436669466C484A3265674541656656504A4F70737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E006A0000000171007E0063, '028b319573ada96c79e13ec26f780103');
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(256) NOT NULL,
  `resource_ids` varchar(256) DEFAULT NULL,
  `client_secret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `authorized_grant_types` varchar(256) DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('app', NULL, '$2a$10$IuJCEGGgF.fvYRBhLE1G1ORdOM8W57TXKfX.wJtgJO0KuQYRu8QNW', 'app', 'client_credentials,password,refresh_token', NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(256) NOT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
  `code` varchar(256) DEFAULT NULL,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of oauth_refresh_token
-- ----------------------------
BEGIN;
INSERT INTO `oauth_refresh_token` VALUES ('4af6c414011191662db8bb84b5abc426', 0xACED00057372004C6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744578706972696E674F417574683252656672657368546F6B656E2FDF47639DD0C9B70200014C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B787200446F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F417574683252656672657368546F6B656E73E10E0A6354D45E0200014C000576616C75657400124C6A6176612F6C616E672F537472696E673B787074059865794A68624763694F694A53557A49314E694973496E523563434936496B705856434A392E65794A316332567958326C755A6D38694F6E7369615751694F6A45774D6A6B324E7A41784D6A49354F444D794E6A41784E6A4173496D567459576C73496A6F694D5445784D5541784E444D7559323974496977696347467A63336476636D51694F6D353162477773496D3570593274755957316C496A6F695A6E4E7A4969776963335268644755694F6A4573496E567A5A584A755957316C496A6F695A6E4E7A4969776959585A6864474679496A7075645778734C434A77614739755A534936626E56736243776963325634496A6F784C434A6961584A30614752686553493649694973496D466B5A484A6C63334D694F6D353162477773496D39795A306C6B496A7075645778734C434A6E636D393163484D694F6D353162477773496D39795A3246756158706864476C7662694936626E567362483073496E567A5A584A66626D46745A534936496D5A7A63794973496E4E6A6233426C496A7062496D467763434A644C434A6864476B694F6949304E3255334E7A46684E79316A4F444D344C5452685A6A6B74596D49784D7931684D7A49774D6A4A6C4D6A51354E4759694C434A6C654841694F6A45314E4451784E6A4D7A4D6A4D73496D463164476876636D6C306157567A496A7062496D5268644745745A476C6A64476C76626D46796554707361584E304969776964584E6C636A707361584E304969776964584E6C636A706B5A57786C644755694C434A6E636D39316344706C5A476C30496977695A334A76645841365A4756735A58526C49697769636D567A62335679593255365A57527064434973496E4A6C63323931636D4E6C4F6D526C624756305A534973496E4E3563794973496D52705933527062323568636E6B74593246305A576476636E6B365A4756735A58526C496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707361584E3049697769636D567A6233567959325536633246325A534973496D5268644745745A476C6A64476C76626D46796554706C5A476C30496977695A476C6A64476C76626D46796553316A5958526C5A3239796554707A59585A6C4969776964584E6C636A706C5A476C30496977695A4746305953316B61574E306157397559584A354F6D526C624756305A534973496E4A6C63323931636D4E6C4F6D7870633351694C434A6E636D39316344707361584E30496977695A4746305953316B61574E306157397559584A354F6E4E68646D55694C434A31633256794F6E4E68646D55694C434A6B61574E306157397559584A354C574E686447566E62334A354F6D566B615851694C434A6E636D39316344707A59585A6C496C3073496D703061534936496A55774D54417A596D45304C5463794E6A67744E474E6C4F4331684E6D466B4C544D324E54426D4F4463324E324E6A4F434973496D4E7361575675644639705A434936496D467763434A392E446F39346A7233444354616448697650637462326D74595F585975786349725857424646314E4C636442583369484738324632304557494846547749496F546570657849785F71782D5072386B596F62704C36387A6C663968696463517247626154576355524F6577655038314855765F323453732D50505A426A734844496A686278507535575F30747357714941334838654B4C514E55665F694A436B376A6854567A356641365A6439666B4D4155694B464334496532444562726F374F7368676A7147474E4C634942374C6D484566757053595F72336A532D73537053696E7558513969387237396370323458724A4E746A2D7A307558586B636C456948313250712D38734742706D6C326A624F3867434D41324354446D585A72707663566A51326C6939747067724F385579414848676D565F59716365417A435A76485238397038724636674A53497A67704A43685F6256417372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000167874E6EAC78, 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000015770400000015737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000001F40200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740016646174612D64696374696F6E6172793A64656C6574657371007E000D740014646174612D64696374696F6E6172793A656469747371007E000D740014646174612D64696374696F6E6172793A6C6973747371007E000D740014646174612D64696374696F6E6172793A736176657371007E000D74001A64696374696F6E6172792D63617465676F72793A64656C6574657371007E000D74001864696374696F6E6172792D63617465676F72793A656469747371007E000D74001864696374696F6E6172792D63617465676F72793A6C6973747371007E000D74001864696374696F6E6172792D63617465676F72793A736176657371007E000D74000C67726F75703A64656C6574657371007E000D74000A67726F75703A656469747371007E000D74000A67726F75703A6C6973747371007E000D74000A67726F75703A736176657371007E000D74000F7265736F757263653A64656C6574657371007E000D74000D7265736F757263653A656469747371007E000D74000D7265736F757263653A6C6973747371007E000D74000D7265736F757263653A736176657371007E000D7400037379737371007E000D74000B757365723A64656C6574657371007E000D740009757365723A656469747371007E000D740009757365723A6C6973747371007E000D740009757365723A736176657871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E003C787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E003A4C000573636F706571007E003C7870740003617070737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E003A7870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000037708000000040000000274000A6772616E745F7479706574000870617373776F7264740008757365726E616D6574000366737378737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000174000361707078017371007E004B770C000000103F40000000000000787371007E00423F40000000000000770800000010000000007870707371007E004B770C000000103F40000000000000787371007E004B770C000000103F40000000000000787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000001F40200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000001577040000001571007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E00377871007E0055737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F726465727871007E00423F400000000000067708000000080000000271007E004471007E004571007E004671007E004778007073720032636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E426173655573657244657461696C52BF9FE5F1A3EC3A0200024C0004757365727400344C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F7573657264657461696C732F557365723B4C000675736572564F74002A4C636F6D2F66756E6361732F70626F6F742F6D6F64756C652F75706D732F656E746974792F557365723B7870737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000001F40200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E003C4C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E0048737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F7200000000000001F4020000787077040000001571007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E0037787074000366737373720028636F6D2E66756E6361732E70626F6F742E6D6F64756C652E75706D732E656E746974792E55736572E081D1B32366716902000C4900037365784C00076164647265737371007E000E4C000661766174617271007E000E4C0008626972746864617971007E000E4C0005656D61696C71007E000E4C000667726F75707371007E00084C00086E69636B6E616D6571007E000E4C00056F726749647400104C6A6176612F6C616E672F4C6F6E673B4C000870617373776F726471007E000E4C000570686F6E6571007E000E4C000573746174657400134C6A6176612F6C616E672F496E74656765723B4C0008757365726E616D6571007E000E78720022636F6D2E66756E6361732E70626F6F742E636F6D6D6F6E2E42617365456E7469747900000000000000010200014C0002696471007E000578707372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700E4A1F857C40000000000001707074000074000C31313131403134332E636F6D70740003667373707070737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E006A0000000171007E0063);
COMMIT;


-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(190) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `INSTANCE_NAME` varchar(190) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(190) DEFAULT NULL,
  `JOB_GROUP` varchar(190) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(190) NOT NULL,
  `JOB_GROUP` varchar(190) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('quartzScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(190) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `JOB_NAME` varchar(190) NOT NULL,
  `JOB_GROUP` varchar(190) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(190) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for tb_data_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `tb_data_dictionary`;
CREATE TABLE `tb_data_dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL,
  `code` varchar(32) NOT NULL,
  `remark` text,
  `type` varchar(32) NOT NULL,
  `value` varchar(8) NOT NULL,
  `fk_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_aunvlvmd6s3c2ddkcjf849d9` (`code`),
  KEY `fk_layhfd1butuigsscgucmp2okd` (`fk_category_id`),
  CONSTRAINT `fk_layhfd1butuigsscgucmp2okd` FOREIGN KEY (`fk_category_id`) REFERENCES `tb_dictionary_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_data_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `tb_data_dictionary` VALUES (1, '启用', 'STATE_ENABLE', '', 'INTEGER', '1', 1);
INSERT INTO `tb_data_dictionary` VALUES (2, '禁用', 'STATE_DISABLED', '', 'INTEGER', '2', 1);
INSERT INTO `tb_data_dictionary` VALUES (3, '删除', 'STATE_DELETE', '', 'INTEGER', '3', 1);
INSERT INTO `tb_data_dictionary` VALUES (10, '导航类型', 'RESOURCE_TYPE_NAV', '', 'INTEGER', '1', 2);
INSERT INTO `tb_data_dictionary` VALUES (11, '安全类型', 'RESOURCE_TYPE_SECURITY', '', 'INTEGER', '2', 2);
INSERT INTO `tb_data_dictionary` VALUES (12, '管理员角色ID', 'SYSTEM_VAR_ROLE_ID', '', 'LONG', '3', 3);
COMMIT;

-- ----------------------------
-- Table structure for tb_dictionary_category
-- ----------------------------
DROP TABLE IF EXISTS `tb_dictionary_category`;
CREATE TABLE `tb_dictionary_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(16) NOT NULL,
  `name` varchar(32) NOT NULL,
  `remark` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_9qkei4dxobl1lm4oa0ys8c3nr` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_dictionary_category
-- ----------------------------
BEGIN;
INSERT INTO `tb_dictionary_category` VALUES (1, 'STATE', '状态', NULL);
INSERT INTO `tb_dictionary_category` VALUES (2, 'RESOURCE_TYPE', '资源类型', NULL);
INSERT INTO `tb_dictionary_category` VALUES (3, 'SYSTEM_VAR', '系统类型', '系统类型');
COMMIT;

-- ----------------------------
-- Table structure for tb_group
-- ----------------------------
DROP TABLE IF EXISTS `tb_group`;
CREATE TABLE `tb_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL,
  `remark` text,
  `org_id` bigint(20) DEFAULT NULL,
  `data_scope` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_byw2jrrrxrueqimkmgj3o842j` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1062152258268954626 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_group
-- ----------------------------
BEGIN;
INSERT INTO `tb_group` VALUES (1, '普通用户', '', 0, 9);
INSERT INTO `tb_group` VALUES (2, '运维人员', '', 0, 3);
INSERT INTO `tb_group` VALUES (3, '超级管理员', '超级管理员', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for tb_group_resource
-- ----------------------------
DROP TABLE IF EXISTS `tb_group_resource`;
CREATE TABLE `tb_group_resource` (
  `fk_resource_id` bigint(20) NOT NULL,
  `fk_group_id` bigint(20) NOT NULL,
  PRIMARY KEY (`fk_resource_id`,`fk_group_id`),
  KEY `fk_q82fpmfh128qxoeyymrkg71e2` (`fk_group_id`),
  CONSTRAINT `fk_3tjs4wt3vvoibo1fvcvog5srd` FOREIGN KEY (`fk_resource_id`) REFERENCES `tb_resource` (`id`),
  CONSTRAINT `fk_q82fpmfh128qxoeyymrkg71e2` FOREIGN KEY (`fk_group_id`) REFERENCES `tb_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_group_resource
-- ----------------------------
BEGIN;
INSERT INTO `tb_group_resource` VALUES (2, 1);
INSERT INTO `tb_group_resource` VALUES (6, 1);
INSERT INTO `tb_group_resource` VALUES (7, 1);
INSERT INTO `tb_group_resource` VALUES (8, 1);
INSERT INTO `tb_group_resource` VALUES (9, 1);
INSERT INTO `tb_group_resource` VALUES (10, 1);
INSERT INTO `tb_group_resource` VALUES (11, 1);
INSERT INTO `tb_group_resource` VALUES (12, 1);
INSERT INTO `tb_group_resource` VALUES (13, 1);
INSERT INTO `tb_group_resource` VALUES (15, 1);
INSERT INTO `tb_group_resource` VALUES (16, 1);
INSERT INTO `tb_group_resource` VALUES (17, 1);
INSERT INTO `tb_group_resource` VALUES (18, 1);
INSERT INTO `tb_group_resource` VALUES (19, 1);
INSERT INTO `tb_group_resource` VALUES (20, 1);
INSERT INTO `tb_group_resource` VALUES (21, 1);
INSERT INTO `tb_group_resource` VALUES (22, 1);
INSERT INTO `tb_group_resource` VALUES (990792035847897088, 1);
INSERT INTO `tb_group_resource` VALUES (1061795714310340609, 1);
INSERT INTO `tb_group_resource` VALUES (1061795843591372801, 1);
INSERT INTO `tb_group_resource` VALUES (1061796635891204097, 1);
INSERT INTO `tb_group_resource` VALUES (1061796792326160384, 1);
INSERT INTO `tb_group_resource` VALUES (1061796876346458113, 1);
INSERT INTO `tb_group_resource` VALUES (1061796962749120512, 1);
INSERT INTO `tb_group_resource` VALUES (1062237803993104384, 1);
INSERT INTO `tb_group_resource` VALUES (1062239403281219584, 1);
INSERT INTO `tb_group_resource` VALUES (1062239572546551808, 1);
INSERT INTO `tb_group_resource` VALUES (1062239650648686593, 1);
INSERT INTO `tb_group_resource` VALUES (1062239772619046913, 1);
INSERT INTO `tb_group_resource` VALUES (1062239960465145856, 1);
INSERT INTO `tb_group_resource` VALUES (1062240022591176704, 1);
INSERT INTO `tb_group_resource` VALUES (1062240186521354241, 1);
INSERT INTO `tb_group_resource` VALUES (1062240281648168960, 1);
INSERT INTO `tb_group_resource` VALUES (1062240364850577408, 1);
INSERT INTO `tb_group_resource` VALUES (15, 2);
INSERT INTO `tb_group_resource` VALUES (16, 2);
INSERT INTO `tb_group_resource` VALUES (17, 2);
INSERT INTO `tb_group_resource` VALUES (18, 2);
INSERT INTO `tb_group_resource` VALUES (19, 2);
INSERT INTO `tb_group_resource` VALUES (20, 2);
INSERT INTO `tb_group_resource` VALUES (21, 2);
INSERT INTO `tb_group_resource` VALUES (22, 2);
INSERT INTO `tb_group_resource` VALUES (1061795843591372801, 2);
INSERT INTO `tb_group_resource` VALUES (1061796635891204097, 2);
INSERT INTO `tb_group_resource` VALUES (1061796792326160384, 2);
INSERT INTO `tb_group_resource` VALUES (2, 3);
INSERT INTO `tb_group_resource` VALUES (3, 3);
INSERT INTO `tb_group_resource` VALUES (4, 3);
INSERT INTO `tb_group_resource` VALUES (5, 3);
INSERT INTO `tb_group_resource` VALUES (6, 3);
INSERT INTO `tb_group_resource` VALUES (7, 3);
INSERT INTO `tb_group_resource` VALUES (8, 3);
INSERT INTO `tb_group_resource` VALUES (9, 3);
INSERT INTO `tb_group_resource` VALUES (10, 3);
INSERT INTO `tb_group_resource` VALUES (11, 3);
INSERT INTO `tb_group_resource` VALUES (12, 3);
INSERT INTO `tb_group_resource` VALUES (13, 3);
INSERT INTO `tb_group_resource` VALUES (15, 3);
INSERT INTO `tb_group_resource` VALUES (16, 3);
INSERT INTO `tb_group_resource` VALUES (17, 3);
INSERT INTO `tb_group_resource` VALUES (18, 3);
INSERT INTO `tb_group_resource` VALUES (19, 3);
INSERT INTO `tb_group_resource` VALUES (20, 3);
INSERT INTO `tb_group_resource` VALUES (21, 3);
INSERT INTO `tb_group_resource` VALUES (22, 3);
INSERT INTO `tb_group_resource` VALUES (990792035847897088, 3);
INSERT INTO `tb_group_resource` VALUES (1061795714310340609, 3);
INSERT INTO `tb_group_resource` VALUES (1061795843591372801, 3);
INSERT INTO `tb_group_resource` VALUES (1061796635891204097, 3);
INSERT INTO `tb_group_resource` VALUES (1061796792326160384, 3);
INSERT INTO `tb_group_resource` VALUES (1061796876346458113, 3);
INSERT INTO `tb_group_resource` VALUES (1061796962749120512, 3);
INSERT INTO `tb_group_resource` VALUES (1062237803993104384, 3);
INSERT INTO `tb_group_resource` VALUES (1062239403281219584, 3);
INSERT INTO `tb_group_resource` VALUES (1062239572546551808, 3);
INSERT INTO `tb_group_resource` VALUES (1062239650648686593, 3);
INSERT INTO `tb_group_resource` VALUES (1062239772619046913, 3);
INSERT INTO `tb_group_resource` VALUES (1062239960465145856, 3);
INSERT INTO `tb_group_resource` VALUES (1062240022591176704, 3);
INSERT INTO `tb_group_resource` VALUES (1062240186521354241, 3);
INSERT INTO `tb_group_resource` VALUES (1062240281648168960, 3);
INSERT INTO `tb_group_resource` VALUES (1062240364850577408, 3);
COMMIT;

-- ----------------------------
-- Table structure for tb_group_unit
-- ----------------------------
DROP TABLE IF EXISTS `tb_group_unit`;
CREATE TABLE `tb_group_unit` (
  `group_id` bigint(20) NOT NULL COMMENT '角色编号',
  `unit_id` bigint(20) NOT NULL COMMENT '机构编号',
  PRIMARY KEY (`group_id`,`unit_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='角色-机构';

-- ----------------------------
-- Records of tb_group_unit
-- ----------------------------
BEGIN;
INSERT INTO `tb_group_unit` VALUES (1, 1);
INSERT INTO `tb_group_unit` VALUES (1, 2);
COMMIT;

-- ----------------------------
-- Table structure for tb_group_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_group_user`;
CREATE TABLE `tb_group_user` (
  `fk_group_id` bigint(20) NOT NULL,
  `fk_user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`fk_group_id`,`fk_user_id`),
  KEY `fk_7k068ltfepa1q75qtmvxuawk` (`fk_user_id`),
  CONSTRAINT `fk_7k068ltfepa1q75qtmvxuawk` FOREIGN KEY (`fk_user_id`) REFERENCES `tb_user` (`id`),
  CONSTRAINT `fk_rgmkki7dggfag6ow6eivljmwv` FOREIGN KEY (`fk_group_id`) REFERENCES `tb_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_group_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_group_user` VALUES (1, 3);
INSERT INTO `tb_group_user` VALUES (2, 4);
INSERT INTO `tb_group_user` VALUES (3, 5);
INSERT INTO `tb_group_user` VALUES (3, 1028266440337129473);
INSERT INTO `tb_group_user` VALUES (2, 1029670122983260160);
INSERT INTO `tb_group_user` VALUES (1, 1033287746405269505);
COMMIT;

-- ----------------------------
-- Table structure for tb_operating_record
-- ----------------------------
DROP TABLE IF EXISTS `tb_operating_record`;
CREATE TABLE `tb_operating_record` (
  `id` bigint(20) NOT NULL,
  `end_date` datetime(3) DEFAULT NULL,
  `fk_user_id` varchar(32) DEFAULT NULL,
  `operating_target` varchar(512) DEFAULT NULL,
  `start_date` datetime(3) DEFAULT NULL,
  `username` varchar(32) DEFAULT NULL,
  `func` varchar(128) DEFAULT NULL,
  `ip` varchar(64)  DEFAULT NULL,
  `method` varchar(256)  DEFAULT NULL,
  `module` varchar(128) DEFAULT NULL,
  `remark` text ,
  `state` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_operating_record
-- ----------------------------
BEGIN;
INSERT INTO `tb_operating_record` VALUES (1, '2018-05-03 18:03:20.000', '5', NULL, NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tb_operating_record` VALUES (2, '2018-05-03 18:03:20.000', '5', NULL, NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tb_operating_record` VALUES (3, '2018-05-03 18:03:20.000', '5', NULL, NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tb_operating_record` VALUES (1059629960026710017, '2018-11-05 20:14:04.000', NULL, '/api/sys/job', '2018-11-05 20:14:04.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059641068095598594, '2018-11-05 20:58:12.000', NULL, '/api/sys/job', '2018-11-05 20:58:12.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059641499710451713, '2018-11-05 20:59:55.000', NULL, '/api/sys/job', '2018-11-05 20:58:24.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059641713544458241, '2018-11-05 21:00:46.000', NULL, '/api/sys/job', '2018-11-05 20:59:59.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059642380296183810, '2018-11-05 21:03:25.000', NULL, '/api/sys/job', '2018-11-05 21:02:59.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059643264073814018, '2018-11-05 21:06:56.000', NULL, '/api/sys/job', '2018-11-05 21:06:47.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059650164211404801, '2018-11-05 21:34:21.000', NULL, '/api/sys/job', '2018-11-05 21:34:21.000', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
INSERT INTO `tb_operating_record` VALUES (1059651127257169921, '2018-11-05 21:38:10.728', NULL, '/api/sys/job', '2018-11-05 21:38:10.691', NULL, '保存定时器', '127.0.0.1', 'saveJob', '定时任务', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for tb_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS `tb_quartz_job`;
CREATE TABLE `tb_quartz_job` (
  `id` bigint(20) NOT NULL,
  `job_class_name` varchar(128)  NOT NULL,
  `parameter` varchar(128) DEFAULT NULL,
  `cron_expression` varchar(16)  DEFAULT NULL,
  `state` tinyint(1) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `ctime` datetime DEFAULT NULL,
  `created` bigint(20) DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_quartz_job
-- ----------------------------
BEGIN;
INSERT INTO `tb_quartz_job` VALUES (1, 'com.funcas.pboot.jobs.SimpleJob', NULL, '0/15 * * * * ?', 3, '这是一个不带参数的定时任务', '2018-11-05 14:37:24', NULL, 0);
INSERT INTO `tb_quartz_job` VALUES (1059357054302420992, 'com.funcas.pboot.jobs.SimpleJobWithParam', 'hello quartz', '0/10 * * * * ?', 3, '这是一个测试带参数的定时器，什么也没做', '2018-11-05 02:09:38', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_resource
-- ----------------------------
DROP TABLE IF EXISTS `tb_resource`;
CREATE TABLE `tb_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `component` varchar(64) DEFAULT NULL,
  `permission` varchar(64) DEFAULT NULL,
  `remark` text,
  `sort` int(11) NOT NULL,
  `name` varchar(16) NOT NULL,
  `type` int(2) NOT NULL,
  `value` varchar(256) DEFAULT NULL,
  `fk_parent_id` bigint(20) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_k2heqvi9muk4cjyyd53r9y37x` (`fk_parent_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_resource
-- ----------------------------
BEGIN;
INSERT INTO `tb_resource` VALUES (1, 'main', 'upms', '', 1, '权限管理', 1, '/account', NULL, 'glyphicon fa fa-shield');
INSERT INTO `tb_resource` VALUES (2, '/count-to/count-to', '', '', 2, '用户管理', 1, '/user/list', 1, 'glyphicon fa fa-user');
INSERT INTO `tb_resource` VALUES (3, '/count-to/count-to', 'user:save', '', 3, '保存用户', 2, '', 2, '');
INSERT INTO `tb_resource` VALUES (4, '/count-to/count-to', 'user:delete', '', 4, '删除用户', 2, '', 2, '');
INSERT INTO `tb_resource` VALUES (5, '/count-to/count-to', 'user:edit', '', 5, '编辑用户', 2, '', 2, '');
INSERT INTO `tb_resource` VALUES (6, '/count-to/count-to', '', '', 6, '组管理', 1, '/group/list', 1, 'glyphicon fa fa-group');
INSERT INTO `tb_resource` VALUES (7, 'ACCOUNT_GROUP_SAVE', 'group:save', '', 7, '保存组', 2, '', 6, '');
INSERT INTO `tb_resource` VALUES (8, 'ACCOUNT_GROUP_EDIT', 'group:edit', '', 8, '编辑组', 2, '', 6, '');
INSERT INTO `tb_resource` VALUES (9, 'ACCOUNT_GROUP_DELETE', 'group:delete', '', 9, '删除组', 2, '', 6, '');
INSERT INTO `tb_resource` VALUES (10, '/count-to/count-to', '', '', 10, '资源管理', 1, '/resource/list', 1, 'glyphicon fa fa-ticket');
INSERT INTO `tb_resource` VALUES (11, 'ACCOUNT_RESOURCE_SAVE', 'resource:save', '', 11, '保存资源', 2, '', 10, '');
INSERT INTO `tb_resource` VALUES (12, 'ACCOUNT_RESOURCE_EDIT', 'resource:edit', '', 12, '编辑资源', 2, '', 10, '');
INSERT INTO `tb_resource` VALUES (13, 'ACCOUNT_RESOURCE_DELETE', 'resource:delete', '', 13, '删除资源', 2, '', 10, '');
INSERT INTO `tb_resource` VALUES (14, 'main', 'sys', '', 14, '系统管理', 1, '/variable', NULL, 'glyphicon fa fa-cogs');
INSERT INTO `tb_resource` VALUES (15, '/count-to/count-to', '', '', 15, '数据字典管理', 1, '/data-dictionary/list', 14, 'glyphicon fa fa-book');
INSERT INTO `tb_resource` VALUES (16, 'SYSTEM_DATA_DICTIONARY_SAVE', 'data-dictionary:save', '', 16, '保存数据字典', 2, '', 15, '');
INSERT INTO `tb_resource` VALUES (17, 'SYSTEM_DATA_DICTIONARY_EDIT', 'data-dictionary:edit', '', 17, '编辑数据字典', 2, '', 15, '');
INSERT INTO `tb_resource` VALUES (18, 'SYSTEM_DATA_DICTIONARY_DELETE', 'data-dictionary:delete', '', 18, '删除数据字典', 2, '', 15, '');
INSERT INTO `tb_resource` VALUES (19, '/count-to/count-to', '', '', 19, '字典类别管理', 1, '/dictionary-category/list', 14, 'glyphicon fa fa-building');
INSERT INTO `tb_resource` VALUES (20, 'SYSTEM_DICTIONARY_CATEGORY_SAVE', 'dictionary-category:save', '', 20, '保存字典类别', 2, '', 19, '');
INSERT INTO `tb_resource` VALUES (21, 'SYSTEM_DICTIONARY_CATEGORY_EDIT', 'dictionary-category:edit', '', 21, '编辑字典类别', 2, '', 19, '');
INSERT INTO `tb_resource` VALUES (22, 'SYSTEM_DICTIONARY_CATEGORY_DELETE', 'dictionary-category:delete', '', 22, '删除字典类别', 2, '', 19, '');
INSERT INTO `tb_resource` VALUES (23, '/count-to/count-to', 'proj:list', NULL, 99, '项目管理', 1, '', NULL, NULL);
INSERT INTO `tb_resource` VALUES (990792035847897088, '/count-to/count-to', '', '', 22, '部门管理', 1, '/account/org/orgList/**', 1, '');
INSERT INTO `tb_resource` VALUES (1061795714310340609, NULL, '', NULL, 26, '定时任务', 1, '/system/schedule', 14, NULL);
INSERT INTO `tb_resource` VALUES (1061795843591372801, NULL, 'audit:list', NULL, 4, '日志查询', 1, '/system/logs', 14, NULL);
INSERT INTO `tb_resource` VALUES (1061796635891204097, NULL, 'job:start', NULL, 26, '启动定时任务', 2, NULL, 1061795714310340609, NULL);
INSERT INTO `tb_resource` VALUES (1061796792326160384, NULL, 'job:stop', NULL, 27, '停止定时任务', 2, NULL, 1061795714310340609, NULL);
INSERT INTO `tb_resource` VALUES (1061796876346458113, NULL, 'job:pause', NULL, 28, '暂停定时任务', 2, NULL, 1061795714310340609, NULL);
INSERT INTO `tb_resource` VALUES (1061796962749120512, NULL, 'job:resmue', NULL, 29, '恢复定时任务', 2, NULL, 1061795714310340609, NULL);
INSERT INTO `tb_resource` VALUES (1062237803993104384, NULL, 'user:list', NULL, 1, '查看用户列表', 1, NULL, 2, NULL);
INSERT INTO `tb_resource` VALUES (1062239403281219584, NULL, 'group:list', NULL, 1, '查看组', 1, NULL, 6, NULL);
INSERT INTO `tb_resource` VALUES (1062239572546551808, NULL, 'resource:list', NULL, 1, '查看资源', 1, NULL, 10, NULL);
INSERT INTO `tb_resource` VALUES (1062239650648686593, NULL, 'unit:list', NULL, 1, '查看部门', 1, NULL, 990792035847897088, NULL);
INSERT INTO `tb_resource` VALUES (1062239772619046913, NULL, 'unit:edit', NULL, 2, '编辑部门', 2, NULL, 990792035847897088, NULL);
INSERT INTO `tb_resource` VALUES (1062239960465145856, NULL, 'unit:save', NULL, 3, '保存部门', 2, NULL, 990792035847897088, NULL);
INSERT INTO `tb_resource` VALUES (1062240022591176704, NULL, 'unit:delete', NULL, 4, '删除部门', 2, NULL, 990792035847897088, NULL);
INSERT INTO `tb_resource` VALUES (1062240186521354241, NULL, 'data-dictionary:list', NULL, 37, '查看数据字典', 2, NULL, 15, NULL);
INSERT INTO `tb_resource` VALUES (1062240281648168960, NULL, 'dictionary-category:list', NULL, 1, '查看字典类别', 2, NULL, 19, NULL);
INSERT INTO `tb_resource` VALUES (1062240364850577408, NULL, 'job:list', NULL, 1, '查看定时任务', 2, NULL, 1061795714310340609, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_unit
-- ----------------------------
DROP TABLE IF EXISTS `tb_unit`;
CREATE TABLE `tb_unit` (
  `id` bigint(20) NOT NULL COMMENT '编号',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父级编号',
  `org_code` varchar(2000) DEFAULT NULL COMMENT '部门编号',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `area_id` varchar(64) DEFAULT NULL COMMENT '归属区域',
  `code` varchar(100) DEFAULT NULL COMMENT '区域编码',
  `type` tinyint(1) DEFAULT NULL COMMENT '机构类型',
  `master` bigint(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(16) DEFAULT NULL COMMENT '电话',
  `state` tinyint(1) DEFAULT NULL COMMENT '是否启用',
  `creator_id` bigint(20) DEFAULT NULL COMMENT '创建者',
  `ctime` datetime DEFAULT NULL COMMENT '创建时间',
  `modifier_id` bigint(20) DEFAULT NULL COMMENT '更新者',
  `mtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
  PRIMARY KEY (`id`),
  KEY `idx_org_parent_id` (`parent_id`),
  KEY `idx_org_del_flag` (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机构表';

-- ----------------------------
-- Records of tb_unit
-- ----------------------------
BEGIN;
INSERT INTO `tb_unit` VALUES (1, 0, '001', '山东省总公司', 10, '2', '100000', 1, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:12', '1', '');
INSERT INTO `tb_unit` VALUES (2, 1, '001001', '公司领导', 10, '2', '100001', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:16', '1', '');
INSERT INTO `tb_unit` VALUES (3, 1, '001002', '综合部', 20, '2', '100002', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:20', '1', '');
INSERT INTO `tb_unit` VALUES (4, 1, '001003', '市场部', 30, '2', '100003', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:23', '1', '');
INSERT INTO `tb_unit` VALUES (5, 1, '001004', '技术部', 40, '2', '100004', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:27', '1', '');
INSERT INTO `tb_unit` VALUES (6, 1, '001005', '研发部', 50, '2', '100005', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:30', '1', '');
INSERT INTO `tb_unit` VALUES (7, 1, '001006', '济南市分公司', 20, '3', '200000', 1, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:37', '1', '');
INSERT INTO `tb_unit` VALUES (8, 7, '001006001', '公司领导', 10, '3', '200001', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:45', '1', '');
INSERT INTO `tb_unit` VALUES (9, 7, '001006002', '综合部', 20, '3', '200002', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:48', '1', '');
INSERT INTO `tb_unit` VALUES (10, 7, '001006003', '市场部', 30, '3', '200003', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:50', '1', '0');
INSERT INTO `tb_unit` VALUES (11, 7, '001006004', '技术部', 40, '3', '200004', NULL, NULL, NULL, 1, NULL, NULL, 1, '2018-08-15 15:03:53', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(16) NOT NULL,
  `password` varchar(256) NOT NULL,
  `email` varchar(64) DEFAULT NULL,
  `nickname` varchar(16) NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `state` int(2) NOT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `birthday` varchar(10) DEFAULT NULL,
  `address` varchar(128) DEFAULT NULL,
  `unit_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `ctime` datetime DEFAULT NULL,
  `creator_id` bigint(20) DEFAULT NULL,
  `mtime` datetime DEFAULT NULL,
  `modifier_id` bigint(20) DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_4wv83hfajry5tdoamn8wsqa6x` (`username`,`email`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (3, 'maintain', 'e10adc3949ba59abbe56e057f20f883e', 'maintain@163.com', '运维用户', NULL, NULL, 1, NULL, NULL, NULL, 2, 1, '2018-08-14 10:57:37', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` VALUES (4, 'user', '$2a$06$VC7xgxaEhyuHU7DvYbD5iepk0oJpFBpxkLJS96b1zAj7xlWTTePb2', 'user@163.com', '普通用户', NULL, NULL, 1, 0, NULL, NULL, 2, NULL, '2018-08-14 10:57:40', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` VALUES (5, 'admin', '$2a$06$/VINc5vla8T5cYFKQPiAD.iXMuCV4kamv/olzQS1ARBeYoomkMUOa', 'administrator@163.com', '超级管理员', 'http://image.biaobaiju.com/uploads/20180918/15/1537256494-ZnSKMzEoBI.jpeg', NULL, 1, 0, NULL, NULL, 1, 1, '2018-08-14 10:57:42', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` VALUES (1028266440337129473, 'funcas', '670b14728ad9902aecba32e22fa4f6bd', '1', 'funcas88', NULL, NULL, 1, 0, NULL, NULL, 2, NULL, '2018-08-14 10:57:45', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` VALUES (1029670122983260160, 'fss', '$2a$06$JO5XpNSYjg7QQrN5fqB7YuaPkBgvJo.vpI0CfiFlHJ2egEAefVPJO', '1111@143.com', 'fss', NULL, NULL, 1, 1, '', NULL, 3, NULL, '2018-08-15 18:04:22', NULL, NULL, NULL, 0);
INSERT INTO `tb_user` VALUES (1033287746405269505, 'fss11', '$2a$06$qR6QkUD0PGHh9HXqp3TNL.2QjSldQovFK7cGTugT3aYhMaUdh.T/C', 'fss@139.com', 'fsfafa', 'http://img4.imgtn.bdimg.com/it/u=48557968,2396647998&fm=26&gp=0.jpg', '13800000592', 1, 0, '2018-08-26', NULL, 4, NULL, '2018-08-25 17:39:30', NULL, NULL, NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
